Tabela TreatmentStepsType

Definicja tabeli TreatmentStepsType

Name

TreatmentStepsType

Code

TreatmentStepsType

Comment

Tabela slownikowa zawierajaca typy etapów leczenia.


Lista kolumn tabeli TreatmentStepsType

Name

Code

TreatmentStepsTypeID

TreatmentStepsTypeID

Code

Code

ShortName

ShortName

FullName

FullName

Active

Active


Kolumna TreatmentStepsTypeID tabeli TreatmentStepsType

Definicja kolumny TreatmentStepsTypeID tabeli TreatmentStepsType

Name

TreatmentStepsTypeID

Code

TreatmentStepsTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Code tabeli TreatmentStepsType

Definicja kolumny Code tabeli TreatmentStepsType

Name

Code

Code

Code

Data Type

VARCHAR2(10)

Mandatory

Yes

Comment

 


Kolumna ShortName tabeli TreatmentStepsType

Definicja kolumny ShortName tabeli TreatmentStepsType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

 


Kolumna FullName tabeli TreatmentStepsType

Definicja kolumny FullName tabeli TreatmentStepsType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna Active tabeli TreatmentStepsType

Definicja kolumny Active tabeli TreatmentStepsType

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Lista kluczy tabeli TreatmentStepsType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TreatmentStepsType

Definicja klucza Identifier_1 tabeli TreatmentStepsType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment